database name, instance name, database domain name, global database name , service name,This is a few concepts that make many beginners easily confused. I believe many beginners are as confused as I am in the title of these concepts. Let's get them
1. Database Name 1.1 The Concept Database Name (db_name) is the identifier of a database, just like the ID card number of a person. If multiple databases are installed on a machine, each database has a database name. After the database is installed
In fact, when creating an object in the database, the Administrator must also name it. Some experienced database administrators will also be careful when naming them. It must be loud and representative of specific application scenarios. Sometimes
For beginners, Database Name (db_name), database instance name (instance_name), operating system environment variable (oracle_sid), Database Service name (SERVICE_NAME), Database domain name (db_domain ), global Database Name (global_name ).
Oh, you
Database Name (db_name), Instance name (instance_name), oracle_sidRecently, some people in the Forum asked about this issue and sorted out their understanding and relevant materials as follows. If not all or improperly, I hope to correct and
ASP get database table name, field name
Take SQL Server as an example:
Copy Code code as follows:
SET conn=server.createobject ("ADODB. Connection ")
Conn.Open "SERVER=IP address; provider=sqloledb;database= library name; uid=
Information A
1, stop the database server, the database MDF files and LDF files copy backup a copy
2, start the database server, delete the suspect database
3, only with the backup of the database MDF file attached to the database,
ASP get database table name, field name
Take SQL Server as an example:
SET conn=server.createobject ("ADODB. Connection ")Conn.Open "SERVER=IP address; provider=sqloledb;database= library name; uid= user name; pwd= password; "%>
Read the table
Http://chinaunix.net/jh/19/348162.html
Recently, some people in the Forum asked about this issue and sorted out their understanding and relevant materials as follows. If not all or improperly, I hope to correct and complete it.
Database Name (db_
Database name (db_name), instance name (instance_name), and operating system environment variables (ORACLE_SID)Only the database name (db_name) and the database instance name (instance_name) are in the ORACLE7, 8 database. A new parameter, the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.